
insheet using "gr2009_rv_data_stata.csv", comma clear
label data "dct_gr2009_rv"
label variable unitid   "Unique identification number of the institution"
label variable grtype   "Cohort data"
label variable chrtstat "Graduation rate status in cohort"
label variable cohort   "Cohort"
label variable section  "Section of survey form"
label variable line     "Original line number of survey form"
label variable xgrtotlt "Imputation field for grtotlt - Grand total"
label variable grtotlt  "Grand total"
label variable xgrtotlm "Imputation field for grtotlm - Total men"
label variable grtotlm  "Total men"
label variable xgrtotlw "Imputation field for grtotlw - Total women"
label variable grtotlw  "Total women"
label variable xdvgrait "Imputation field for dvgrait - American Indian or Alaska Native total - derived"
label variable dvgrait  "American Indian or Alaska Native total - derived"
label variable xdvgraim "Imputation field for dvgraim - American Indian or Alaska Native men - derived"
label variable dvgraim  "American Indian or Alaska Native men - derived"
label variable xdvgraiw "Imputation field for dvgraiw - American Indian or Alaska Native women - derived"
label variable dvgraiw  "American Indian or Alaska Native women - derived"
label variable xdvgrapt "Imputation field for dvgrapt - Asian/Native Hawaiian/Other Pacific Islander total - derived"
label variable dvgrapt  "Asian/Native Hawaiian/Other Pacific Islander total - derived"
label variable xdvgrapm "Imputation field for dvgrapm - Asian/Native Hawaiian/Other Pacific Islander men - derived"
label variable dvgrapm  "Asian/Native Hawaiian/Other Pacific Islander men - derived"
label variable xdvgrapw "Imputation field for dvgrapw - Asian/Native Hawaiian/Other Pacific Islander women - derived"
label variable dvgrapw  "Asian/Native Hawaiian/Other Pacific Islander women - derived"
label variable xdvgrbkt "Imputation field for dvgrbkt - Black or African American/Black non-Hispanic total - derived"
label variable dvgrbkt  "Black or African American/Black non-Hispanic total - derived"
label variable xdvgrbkm "Imputation field for dvgrbkm - Black or African American/Black non-Hispanic men - derived"
label variable dvgrbkm  "Black or African American/Black non-Hispanic men - derived"
label variable xdvgrbkw "Imputation field for dvgrbkw - Black or African American/Black non-Hispanic women - derived"
label variable dvgrbkw  "Black or African American/Black non-Hispanic women - derived"
label variable xdvgrhst "Imputation field for dvgrhst - Hispanic or Latino/Hispanic  total - derived"
label variable dvgrhst  "Hispanic or Latino/Hispanic  total - derived"
label variable xdvgrhsm "Imputation field for dvgrhsm - Hispanic or Latino/Hispanic men - derived"
label variable dvgrhsm  "Hispanic or Latino/Hispanic men - derived"
label variable xdvgrhsw "Imputation field for dvgrhsw - Hispanic or Latino/Hispanic  women - derived"
label variable dvgrhsw  "Hispanic or Latino/Hispanic  women - derived"
label variable xdvgrwht "Imputation field for dvgrwht - White/White non-Hispanic total - derived"
label variable dvgrwht  "White/White non-Hispanic total - derived"
label variable xdvgrwhm "Imputation field for dvgrwhm - White/White non-Hispanic men - derived"
label variable dvgrwhm  "White/White non-Hispanic men - derived"
label variable xdvgrwhw "Imputation field for dvgrwhw - White/White non-Hispanic women - derived"
label variable dvgrwhw  "White/White non-Hispanic women - derived"
label variable xgraiant "Imputation field for graiant - American Indian or Alaska Native total - new"
label variable graiant  "American Indian or Alaska Native total - new"
label variable xgraianm "Imputation field for graianm - American Indian or Alaska Native men - new"
label variable graianm  "American Indian or Alaska Native men - new"
label variable xgraianw "Imputation field for graianw - American Indian or Alaska Native women - new"
label variable graianw  "American Indian or Alaska Native women - new"
label variable xgrasiat "Imputation field for grasiat - Asian total - new"
label variable grasiat  "Asian total - new"
label variable xgrasiam "Imputation field for grasiam - Asian men - new"
label variable grasiam  "Asian men - new"
label variable xgrasiaw "Imputation field for grasiaw - Asian women - new"
label variable grasiaw  "Asian women - new"
label variable xgrbkaat "Imputation field for grbkaat - Black or African American total - new"
label variable grbkaat  "Black or African American total - new"
label variable xgrbkaam "Imputation field for grbkaam - Black or African American men - new"
label variable grbkaam  "Black or African American men - new"
label variable xgrbkaaw "Imputation field for grbkaaw - Black or African American women - new"
label variable grbkaaw  "Black or African American women - new"
label variable xgrhispt "Imputation field for grhispt - Hispanic total - new"
label variable grhispt  "Hispanic total - new"
label variable xgrhispm "Imputation field for grhispm - Hispanic men - new"
label variable grhispm  "Hispanic men - new"
label variable xgrhispw "Imputation field for grhispw - Hispanic women - new"
label variable grhispw  "Hispanic women - new"
label variable xgrnhpit "Imputation field for grnhpit - Native Hawaiian or Other Pacific Islander total - new"
label variable grnhpit  "Native Hawaiian or Other Pacific Islander total - new"
label variable xgrnhpim "Imputation field for grnhpim - Native Hawaiian or Other Pacific Islander men - new"
label variable grnhpim  "Native Hawaiian or Other Pacific Islander men - new"
label variable xgrnhpiw "Imputation field for grnhpiw - Native Hawaiian or Other Pacific Islander women - new"
label variable grnhpiw  "Native Hawaiian or Other Pacific Islander women - new"
label variable xgrwhitt "Imputation field for grwhitt - White total - new"
label variable grwhitt  "White total - new"
label variable xgrwhitm "Imputation field for grwhitm - White men - new"
label variable grwhitm  "White men - new"
label variable xgrwhitw "Imputation field for grwhitw - White women - new"
label variable grwhitw  "White women - new"
label variable xgr2mort "Imputation field for gr2mort - Two or more races total - new"
label variable gr2mort  "Two or more races total - new"
label variable xgr2morm "Imputation field for gr2morm - Two or more races men - new"
label variable gr2morm  "Two or more races men - new"
label variable xgr2morw "Imputation field for gr2morw - Two or more races women - new"
label variable gr2morw  "Two or more races women - new"
label variable xgrrac19 "Imputation field for grrace19 - American Indian or Alaska Native total - old"
label variable grrace19 "American Indian or Alaska Native total - old"
label variable xgrrac05 "Imputation field for grrace05 - American Indian or Alaska Native men - old"
label variable grrace05 "American Indian or Alaska Native men - old"
label variable xgrrac06 "Imputation field for grrace06 - American Indian or Alaska Native women - old"
label variable grrace06 "American Indian or Alaska Native women - old"
label variable xgrrac20 "Imputation field for grrace20 - Asian or Pacific Islander total - old"
label variable grrace20 "Asian or Pacific Islander total - old"
label variable xgrrac07 "Imputation field for grrace07 - Asian or Pacific Islander men - old"
label variable grrace07 "Asian or Pacific Islander men - old"
label variable xgrrac08 "Imputation field for grrace08 - Asian or Pacific Islander women - old"
label variable grrace08 "Asian or Pacific Islander women - old"
label variable xgrrac18 "Imputation field for grrace18 - Black non-Hispanic total - old"
label variable grrace18 "Black non-Hispanic total - old"
label variable xgrrac03 "Imputation field for grrace03 - Black non-Hispanic men - old"
label variable grrace03 "Black non-Hispanic men - old"
label variable xgrrac04 "Imputation field for grrace04 - Black non-Hispanic women - old"
label variable grrace04 "Black non-Hispanic women - old"
label variable xgrrac21 "Imputation field for grrace21 - Hispanic total - old"
label variable grrace21 "Hispanic total - old"
label variable xgrrac09 "Imputation field for grrace09 - Hispanic men - old"
label variable grrace09 "Hispanic men - old"
label variable xgrrac10 "Imputation field for grrace10 - Hispanic women - old"
label variable grrace10 "Hispanic women - old"
label variable xgrrac22 "Imputation field for grrace22 - White non-Hispanic total - old"
label variable grrace22 "White non-Hispanic total - old"
label variable xgrrac11 "Imputation field for grrace11 - White non-Hispanic men - old"
label variable grrace11 "White non-Hispanic men - old"
label variable xgrrac12 "Imputation field for grrace12 - White non-Hispanic women - old"
label variable grrace12 "White non-Hispanic women - old"
label variable xgrunknt "Imputation field for grunknt - Race/ethnicity unknown total"
label variable grunknt  "Race/ethnicity unknown total"
label variable xgrunknm "Imputation field for grunknm - Race/ethnicity unknown men"
label variable grunknm  "Race/ethnicity unknown men"
label variable xgrunknw "Imputation field for grunknw - Race/ethnicity unknown women"
label variable grunknw  "Race/ethnicity unknown women"
label variable xgrnralt "Imputation field for grnralt - Nonresident alien total"
label variable grnralt  "Nonresident alien total"
label variable xgrnralm "Imputation field for grnralm - Nonresident alien men"
label variable grnralm  "Nonresident alien men"
label variable xgrnralw "Imputation field for grnralw - Nonresident alien women"
label variable grnralw  "Nonresident alien women"
label define label_grtype 2 "4-year institutions, Adjusted cohort (revised cohort minus exclusions)"
label define label_grtype 3 "4-year institutions, Completers within 150% of normal time",add
label define label_grtype 4 "4-year institutions, Transfer-out students",add
label define label_grtype 5 "4-year institutions, Still enrolled in long programs",add
label define label_grtype 6 "Bachelor^s or equiv subcohort (4-yr institution)",add
label define label_grtype 8 "Bachelor^s or equiv subcohort (4-yr institution) adjusted cohort (revised cohort minus exclusions)",add
label define label_grtype 9 "Bachelor^s or equiv subcohort (4-yr institution) Completers within 150% of normal time total",add
label define label_grtype 10 "Bachelor^s or equiv subcohort (4-yr institution) Completers of programs of < 2 yrs (150% of normal time)",add
label define label_grtype 11 "Bachelor^s or equiv subcohort (4-yr institution) Completers of programs of 2 but <4 yrs (150% of normal time)",add
label define label_grtype 12 "Bachelor^s or equiv subcohort (4-yr institution) Completers of bachelor's or equiv degrees total (150% of normal time)",add
label define label_grtype 13 "Bachelor^s or equiv subcohort (4-yr institution) Completers of bachelor's or equiv degrees in 4 years or less",add
label define label_grtype 14 "Bachelor^s or equiv subcohort (4-yr institution) Completers of bachelor's or equiv degrees in 5 years",add
label define label_grtype 15 "Bachelor^s or equiv subcohort (4-yr institution) Completers of bachelor's or equiv degrees in 6 years",add
label define label_grtype 16 "Bachelor^s or equiv subcohort (4-yr institution) Transfer-out students",add
label define label_grtype 17 "Bachelor^s or equiv subcohort (4-yr institution) Still enrolled in long programs",add
label define label_grtype 18 "Other degree/certif-seeking subcohort (4-yr institution)",add
label define label_grtype 20 "Other degree/certif-seeking subcohort (4-yr institution) Adjusted cohort (revised cohort minus exclusions)",add
label define label_grtype 21 "Other degree/certif-seeking subcohort (4-yr institution) Completers within 150% of normal time total",add
label define label_grtype 22 "Other degree/certif-seeking subcohort (4-yr institution) Completers of programs < 2 yrs (150% of normal time)",add
label define label_grtype 23 "Other degree/certif-seeking subcohort (4-yr institution) Completers of programs of 2 but < 4 yrs (150% of normal time)",add
label define label_grtype 24 "Other degree/certif-seeking subcohort (4-yr institution) Completers of bachelor^s or equiv degrees (150% of normal time)",add
label define label_grtype 25 "Other degree/certif-seeking subcohort (4-yr institution) Transfer-out students",add
label define label_grtype 26 "Other degree/certif-seeking subcohort (4-yr institution) Still enrolled in long programs",add
label define label_grtype 27 "Degree/certif-seeking students ( 2-yr institution)",add
label define label_grtype 29 "Degree/certif-seeking students ( 2-yr institution) Adjusted cohort (revised cohort minus exclusions)",add
label define label_grtype 30 "Degree/certif-seeking students ( 2-yr institution) Completers within 150% of normal time total",add
label define label_grtype 31 "Degree/certif-seeking students ( 2-yr institution) Completers of programs of < 2 yrs (150% of normal time)",add
label define label_grtype 32 "Degree/certificate-seeking students ( 2-yr institution) Completers of programs of 2 but < 4 yrs (150% of normal time)",add
label define label_grtype 33 "Degree/certif-seeking students ( 2-yr institution) Transfer-out students",add
label define label_grtype 34 "Degree/certif-seeking students ( 2-yr institution) Still enrolled in long programs",add
label define label_grtype 35 "Degree/certif-seeking students ( 2-yr institution) Completers within 100% of normal time total",add
label define label_grtype 36 "Degree/certif-seeking students ( 2-yr institution) Completers of programs of < 2 yrs (100% of normal time)",add
label define label_grtype 37 "Degree/certificate-seeking students ( 2-yr institution) Completers of programs of 2 but < 4 yrs (100% of normal time)",add
label define label_grtype 40 "Total exclusions 4-year schools",add
label define label_grtype 7 "Bachelor^s or equiv subcohort (4-yr institution) exclusions",add
label define label_grtype 19 "Other degree/certificate-seeking subcohort(4-yr institution) exclusions",add
label define label_grtype 28 "Degree/certificate-seeking subcohort(2-yr institution) exclusions",add
label values grtype label_grtype
label define label_chrtstat 10 "Revised cohort"
label define label_chrtstat 11 "Exclusions",add
label define label_chrtstat 12 "Adjusted cohort (revised cohort minus exclusions)",add
label define label_chrtstat 13 "Completers within 150% of normal time",add
label define label_chrtstat 14 "Completers of programs of less than 2 years (150% of normal time)",add
label define label_chrtstat 15 "Completers of programs of 2 but less than 4 years (150% of normal time)",add
label define label_chrtstat 16 "Completers of bachelor^s or equivalent degrees (150% of normal time)",add
label define label_chrtstat 17 "Completers of bachelor^s or equivalent degrees in 4 years or less",add
label define label_chrtstat 18 "Completers of bachelor^s or equivalent degrees in 5 years",add
label define label_chrtstat 19 "Completers of bachelor^s or equivalent degrees in 6 years",add
label define label_chrtstat 20 "Transfer-out students",add
label define label_chrtstat 21 "Still enrolled in long programs",add
label define label_chrtstat 22 "Completers of programs within 100% of normal time total",add
label define label_chrtstat 23 "Completers of programs of < 2 yrs within 100% of normal time (not available by race or gender)",add
label define label_chrtstat 24 "Completers of programs of 2 but < 4 yrs within 100% of normal time (not available by race or gender)",add
label values chrtstat label_chrtstat
label define label_cohort 1 "Bachelor^s/ equiv +  other degree/certif-seeking 2003 subcohorts (4-yr institution)"
label define label_cohort 2 "Bachelor^s or equiv 2003 subcohort (4-yr institution)",add
label define label_cohort 3 "Other degree/certif-seeking 2003 subcohort (4-yr institution)",add
label define label_cohort 4 "Degree/certif-seeking students 2006 cohort ( 2-yr institution)",add
label values cohort label_cohort
label define label_section 1 "Bachelor^s/ equiv +  other degree/certif-seeking 2003 subcohort (4-yr institution)"
label define label_section 2 "Bachelor^s or equiv 2003 subcohort (4-yr institution)",add
label define label_section 3 "Other degree/certif-seeking 2003 subcohort (4-yr institution)",add
label define label_section 4 "Degree/certif-seeking students 2006 cohort ( 2-yr and <2-yr institution)",add
label values section label_section
*label define label_line 10 "Revised cohort"
*label define label_line 45 "Exclusions",add
*label define label_line 50 "Adjusted cohort (revised cohort minus exclusions)",add
*label define label_line 29A "Completers within 150% of normal time",add
*label define label_line 11A "Completers of programs of less than 2 years (150% of normal time)",add
*label define label_line 12A "Completers of programs of 2 but less than 4 years (150% of normal time)",add
*label define label_line 18A "Completers of bachelor^s or equivalent degrees (150% of normal time)",add
*label define label_line 19 "Completers of bachelor^s or equivalent degrees in 4 years or less",add
*label define label_line 20 "Completers of bachelor^s or equivalent degrees in 5 years",add
*label define label_line 21 "Completers of bachelor^s or equivalent degrees in 6 years",add
*label define label_line 30 "Transfer-out students",add
*label define label_line 46 "Still enrolled in long programs (4-year institutions)",add
*label define label_line 47 "Still enrolled in long programs (2-year institutions)",add
*label define label_line 999 "Generated record not on original survey form",add
*label define label_line 57 "Completers of programs within 100% of normal time total (not available by race or gender)",add
*label define label_line 55 "Completers of programs of less than 2 years within 100% of normal time (not available by race or gender)",add
*label define label_line 56 "Completers of programs of 2 but less than 4 years within 100% of normal time (not available by race or gender)",add
*label values line label_line
*The following are the possible values for the item imputation field variables
*A Not applicable
*B Institution left item blank
*C Analyst corrected reported value
*D Do not know
*G Data generated from other data values
*H Value not derived - data not usable
*J Logical imputation
*K Ratio adjustment
*L Imputed using the Group Median procedure
*N Imputed using Nearest Neighbor procedure
*P Imputed using Carry Forward procedure
*R Reported
*Z Implied zero
tab grtype
tab chrtstat
tab cohort
tab section
tab line
tab xgrtotlt
tab xgrtotlm
tab xgrtotlw
tab xdvgrait
tab xdvgraim
tab xdvgraiw
tab xdvgrapt
tab xdvgrapm
tab xdvgrapw
tab xdvgrbkt
tab xdvgrbkm
tab xdvgrbkw
tab xdvgrhst
tab xdvgrhsm
tab xdvgrhsw
tab xdvgrwht
tab xdvgrwhm
tab xdvgrwhw
tab xgraiant
tab xgraianm
tab xgraianw
tab xgrasiat
tab xgrasiam
tab xgrasiaw
tab xgrbkaat
tab xgrbkaam
tab xgrbkaaw
tab xgrhispt
tab xgrhispm
tab xgrhispw
tab xgrnhpit
tab xgrnhpim
tab xgrnhpiw
tab xgrwhitt
tab xgrwhitm
tab xgrwhitw
tab xgr2mort
tab xgr2morm
tab xgr2morw
tab xgrrac19
tab xgrrac05
tab xgrrac06
tab xgrrac20
tab xgrrac07
tab xgrrac08
tab xgrrac18
tab xgrrac03
tab xgrrac04
tab xgrrac21
tab xgrrac09
tab xgrrac10
tab xgrrac22
tab xgrrac11
tab xgrrac12
tab xgrunknt
tab xgrunknm
tab xgrunknw
tab xgrnralt
tab xgrnralm
tab xgrnralw
summarize grtotlt
summarize grtotlm
summarize grtotlw
summarize dvgrait
summarize dvgraim
summarize dvgraiw
summarize dvgrapt
summarize dvgrapm
summarize dvgrapw
summarize dvgrbkt
summarize dvgrbkm
summarize dvgrbkw
summarize dvgrhst
summarize dvgrhsm
summarize dvgrhsw
summarize dvgrwht
summarize dvgrwhm
summarize dvgrwhw
summarize graiant
summarize graianm
summarize graianw
summarize grasiat
summarize grasiam
summarize grasiaw
summarize grbkaat
summarize grbkaam
summarize grbkaaw
summarize grhispt
summarize grhispm
summarize grhispw
summarize grnhpit
summarize grnhpim
summarize grnhpiw
summarize grwhitt
summarize grwhitm
summarize grwhitw
summarize gr2mort
summarize gr2morm
summarize gr2morw
summarize grrace19
summarize grrace05
summarize grrace06
summarize grrace20
summarize grrace07
summarize grrace08
summarize grrace18
summarize grrace03
summarize grrace04
summarize grrace21
summarize grrace09
summarize grrace10
summarize grrace22
summarize grrace11
summarize grrace12
summarize grunknt
summarize grunknm
summarize grunknw
summarize grnralt
summarize grnralm
summarize grnralw
save "dct_gr2009_rv.dta", replace

*Get adjusted bachelor's cohort at 4-year institutions, and completers of bachelor's degrees within 150% of normal time for Bachelor's at 4-year institution
keep if grtype==12|grtype==8

*Check that each university has no more than 2 observations
bysort unitid: egen totobs = count(unitid)
tab totobs, missing

keep unitid grtype grtotlt 
save "dct_gr2009_rv_small.dta", replace

